package cn.iocoder.yudao.module.system.controller.admin.ranking.vo;

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;

import java.io.Serializable;

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@Accessors(chain = false)
public class RankingImportExcelVO implements Serializable {


    private static final long serialVersionUID = -5711674225964914202L;
    @ExcelProperty(value = {"序号","序号"},index = 0)
    private String serialNumber;

    @ExcelProperty(value ={"企业名称","企业名称"},index = 1)
    private String companyName;

    @ExcelProperty(value = {"企业成立时间\n" +
            "（年）","企业成立时间\n" +
            "（年）"},index = 2)
    private String establishmentDate; // 类型根据实际需求调整（如 Date/LocalDateTime）

    @ExcelProperty(value = {"技术创新指标","研发费用金额\n" +
            "（万元）"})
    private String rdExpenseAmount;

    @ExcelProperty("研发费用增速\n" +
            "（%）")
    private String rdExpenseGrowthRate;

    @ExcelProperty("研发费用占营业收入的比例（%）")
    private String rdExpenseRevenueRatio;

    @ExcelProperty("科技人员占职工总数的比重（%）")
    private String techStaffRatio;

    @ExcelProperty("与主营业务相关的发明专利申请量（件）")
    private String inventionPatentApplications;

    @ExcelProperty("与主营业务相关的PCT专利申请量（件）")
    private String pctPatentApplications;

    @ExcelProperty("企业技术合同成交额（万元）")
    private String techContractAmount;

    @ExcelProperty(value = {"成长经营指标","高新技术产品收入（万元）"})
    private String highTechProductRevenue;

    @ExcelProperty("营业收入（万元）")
    private String operatingRevenue;

    @ExcelProperty("营业收入增长率（%）")
    private String operatingRevenueGrowthRate;

    @ExcelProperty("研究生以上人员占比（%）")
    private String postgraduateRatio;

    @ExcelProperty("研发费用加计扣除所得税减免额（万元）")
    private String rdTaxDeduction;

    @ExcelProperty("净资产利润率（%）")
    private String netAssetProfitMargin;

    @ExcelProperty(value = {"辅助指标","吸纳高校应届毕业生人数（人）"})
    private String graduateHireCount;

    @ExcelProperty("承担建设省级及以上研发或创新平台数量（项）")
    private String provincialPlatformCount;

    @ExcelProperty("获得省级及以上科技奖励数量（项）")
    private String provincialAwardsCount;

    @ExcelProperty("承担省级及以上科技计划项目数量（项）")
    private String provincialProjectCount;

    @ExcelProperty("获得风险投资金额（万元）")
    private String ventureCapitalAmount;

}